Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

Composite key

This is not a multiple key problem.
You need an additional view.
Do a copy/paste of your lookup view.
Say the first colum evaluates to dsp1 and the second to dsp2.
Replace the first 2 columns by only one sorted column with a formula like @Text(dsp1)+"*"+@Text(dsp2). You have now only 2 columns left in your new view named say "myview".
In your form, the formula of the lookup in your 3rd field should now be:

mykey := @Text(field1)+"*"+@Text(field2);
@DbLookup("":"NoCache;"";"myview";mykey;2)


Hope this helps.
Thierry Cayla
http://dominoeffects.serveblog.net


Feedback response number WEBB7WBL6E created by ~Karl Rekimarettu on 09/28/2009

DBlookup using multiple key (~Tony Loptumiko... 25.Sep.09)
. . If you can, use LotusScript. (~James Brewever... 29.Sep.09)
. . Don't do it (~George Chugero... 28.Sep.09)
. . Composite key (~Karl Rekimaret... 28.Sep.09)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS